From 5f8901b9c3c50496bb9a0f8440a5eb5daec1e292 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 31 Jul 2026 15:37:55 +0000 Subject: [PATCH] Fix build_swelling_states() to remove data on former females --- .../sokwedb/functions/create/build_swelling_states.m4 | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/db/schemas/sokwedb/functions/create/build_swelling_states.m4 b/db/schemas/sokwedb/functions/create/build_swelling_states.m4 index 526a32e..448a242 100644 --- a/db/schemas/sokwedb/functions/create/build_swelling_states.m4 +++ b/db/schemas/sokwedb/functions/create/build_swelling_states.m4 @@ -50,6 +50,13 @@ CREATE OR REPLACE FUNCTION build_swelling_states() a_result INT := 0; BEGIN + -- Remove all the SWELLING_STATES of individuals who were + -- female but have changed sex + DELETE FROM swelling_states + USING biography_data + WHERE biography_data.animid = swelling_states.animid + AND biography_data.sex <> 'sdb_female'; + FOR a_animid IN SELECT biography_data.animid FROM biography_data -- 2.34.1